﻿CREATE PROCEDURE [dbo].[sp_Update_DefaultAgentRatio]
	@ID int
AS
	UPDATE [dbo].[Agents]
   SET [ActiveContacts] = 0.9
      ,[ActiveAppointMade] = 0.5
      ,[ActiveAppointKept] = 0.75
      ,[ActivePresentation] = 0.6
      ,[ActiveAppointSale] = 0.25
      ,[LapsedContacts] = 0.6
      ,[LapsedAppointMade] = 0.4
      ,[LapsedAppointKept] = 0.6
      ,[LapsedPresentation] = 0.5	
      ,[LapsedAppointSale] = 0.25
      ,[NeighborContacts] = 0.9
      ,[NeighborAppointMade] = 0.5
      ,[NeighborAppointKept] = 0.6
      ,[NeighborPresentation] = 0.33
      ,[NeighborAppointSale] = 0.25
      ,[BusinessContacts] = 0.7
      ,[BusinessAppointMade] = 0.6
      ,[BusinessAppointKept] = 0.5
      ,[BusinessPresentation] = 0.33
      ,[BusinessAppointSale] = 0.25
      ,[RefContacts] = 0.6
      ,[RefAppointMade] = 0.5
      ,[RefAppointKept] = 0.6
      ,[RefPresentation] = 0.33
      ,[RefAppointSale] = 0.25
      ,[TSystemContacts] = 0.9
      ,[TSystemAppointMade] = 0.5
      ,[TSystemAppointKept] = 0.6
      ,[TSystemPresentation] = 0.33
      ,[TSystemAppointSale] = 0.25
      ,[TargetMarketContacts] = 0.75
      ,[TargetMarketAppointMade] = 0.5
      ,[TargetMarketAppointKept] = 0.6
      ,[TargetMarketPresentation] = 0.33
      ,[TargetMarketAppointSale] = 0.25
      ,[FieldContacts] = 0.9
      ,[FieldAppointMade] = 0.5
      ,[FieldAppointKept] = 0.75
      ,[FieldPresentation] = 0.6
      ,[FieldAppointSale] = 0.25
      ,[AvgAPVperApp] = 475
		WHERE ID = @ID